////////////////////////////////////////////////////////////////////////////////
// Copyright 2007 CORE Solutions Limited
// All rights reserved.
// PROPRIETARY AND CONFIDENTIAL INFORMATION.
// Use is subject to license terms.
//
// FUNCTION ID      :   CATALOG_SECURITY
// AUTHOR           :   Saint Peng
// DATE CREATE      :   2007/03/29
// DESCRIPTION      :   a SCHEMA file for the function, CATALOG_SECURITY
//                  :
//                  :
//                  :
//
// MODIFICATION HISTORY:
// DATE         AUTHOR          VERSION NO.         COMMENT
// -----------  --------------  ------------------  -------------------
// 2007/03/29   Saint Peng      1.0                 source is generated.
//
//
//
////////////////////////////////////////////////////////////////////////////////

package com.erp.app.catalog.catalogSecurity.schema;

import com.erp.framework.model.schema.MetaData;
import com.erp.framework.model.schema.TableSchema;

/**
* <p>A <strong>Schema</strong> stores the table meta information.
* The main purpose for this class is to validate the lengths of UniCode Characters,
* and notify the database to store UniCode characters from web browsers.
*
* @author          Saint Peng
* @version 1.0     2007/03/29
* @since           FrameWork 1.0
*
*/
public class CatalogSecurityHdrSchema extends TableSchema {

	public static final String TABLE_NAME = "T_CATALOG_SECURITY_HDR";

	public CatalogSecurityHdrSchema(){

		MetaData md = null;

		md = new MetaData();
		md.setColumnName("COMPANY_CODE");
		md.setVoPropertyName("companyCode");
		md.setColumnTitle("COMPANY_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(30);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(30);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_HDR_COMPANY_CODE");
		md.setWebLabelName("DEF HDR COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_MAINT_MOD_NAME");
		md.setVoPropertyName("lblMaintModName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_MAINT_MOD_NAME");
		md.setWebLabelName("DEF MAINT MOD NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SEARCH_MOD_NAME");
		md.setVoPropertyName("lblSearchModName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SEARCH_MOD_NAME");
		md.setWebLabelName("DEF SEARCH MOD NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_COMPANY_CODE");
		md.setVoPropertyName("lblSrchCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_COMPANY_CODE");
		md.setWebLabelName("DEF SRCH COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_LOGIN_PARTY");
		md.setVoPropertyName("lblSrchLoginParty");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_LOGIN_PARTY");
		md.setWebLabelName("DEF SRCH LOGIN PARTY");
		ts.add(md);


		md = new MetaData();
		md.setColumnName("LBL_SRCH_ROLE_GROUP_ID");
		md.setVoPropertyName("lblSrchRoleGroupId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_ROLE_GROUP_ID");
		md.setWebLabelName("DEF SRCH ROLE GROUP ID");
		ts.add(md);


		md = new MetaData();
		md.setColumnName("LBL_GRID_COMPANY_CODE");
		md.setVoPropertyName("lblGridCompanyCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_COMPANY_CODE");
		md.setWebLabelName("DEF GRID COMPANY CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("USER_CODE");
		md.setVoPropertyName("userCode");
		md.setColumnTitle("USER_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(35);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(35);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_HDR_USER_CODE");
		md.setWebLabelName("DEF HDR USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_USER_CODE");
		md.setVoPropertyName("lblSrchUserCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_USER_CODE");
		md.setWebLabelName("DEF SRCH USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_USER_CODE");
		md.setVoPropertyName("lblGridUserCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_USER_CODE");
		md.setWebLabelName("DEF GRID USER CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("USER_ID");
		md.setVoPropertyName("hdrUserId");
		md.setColumnTitle("USER_ID");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(30);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(30);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_HDR_USER_ID");
		md.setWebLabelName("DEF HDR USER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_USER_ID");
		md.setVoPropertyName("lblSrchHdrUserId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_USER_ID");
		md.setWebLabelName("DEF SRCH USER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_USER_ID");
		md.setVoPropertyName("lblGridHdrUserId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_USER_ID");
		md.setWebLabelName("DEF GRID USER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("USER_NAME");
		md.setVoPropertyName("hdrUserName");
		md.setColumnTitle("USER_NAME");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(100);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(100);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_HDR_USER_NAME");
		md.setWebLabelName("DEF HDR USER NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_USER_NAME");
		md.setVoPropertyName("lblSrchHdrUserName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_USER_NAME");
		md.setWebLabelName("DEF SRCH USER NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_USER_NAME");
		md.setVoPropertyName("lblGridHdrUserName");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_USER_NAME");
		md.setWebLabelName("DEF GRID USER NAME");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("USER_GROUP_CODE");
		md.setVoPropertyName("hdrUserGroupCode");
		md.setColumnTitle("USER_GROUP_CODE");
		md.setColumnTypeName("VARCHAR2");
		md.setColumnType(12);
		md.setColumnSize(30);
		md.setColumnCatalogName("");
		md.setColumnClassName("java.lang.String");
		md.setColumnPrecision(30);
		md.setColumnScale(0);
		md.setDisplaySize(30);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_HDR_USER_GROUP_CODE");
		md.setWebLabelName("DEF HDR USER GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_USER_GROUP_CODE");
		md.setVoPropertyName("lblSrchHdrUserGroupCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_USER_GROUP_CODE");
		md.setWebLabelName("DEF SRCH USER GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_USER_GROUP_CODE");
		md.setVoPropertyName("lblGridHdrUserGroupCode");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_USER_GROUP_CODE");
		md.setWebLabelName("DEF GRID USER GROUP CODE");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("CATALOG_USER_ID");
		md.setVoPropertyName("hdrCatalogUserId");
		md.setColumnTitle("CATALOG_USER_ID");
		md.setColumnTypeName("NUMBER");
		md.setColumnType(2);
		md.setColumnSize(22);
		md.setColumnCatalogName("");
		md.setColumnClassName("com.erp.framework.types.CustomBigInteger");
		md.setColumnPrecision(8);
		md.setColumnScale(0);
		md.setDisplaySize(22);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(0);
		md.setWebObjectId("LBL_HDR_CATALOG_USER_ID");
		md.setWebLabelName("DEF HDR CATALOG USER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_SRCH_CATALOG_USER_ID");
		md.setVoPropertyName("lblSrchHdrCatalogUserId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_SRCH_CATALOG_USER_ID");
		md.setWebLabelName("DEF SRCH CATALOG USER ID");
		ts.add(md);

		md = new MetaData();
		md.setColumnName("LBL_GRID_CATALOG_USER_ID");
		md.setVoPropertyName("lblGridHdrCatalogUserId");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		md.setWebObjectId("LBL_GRID_CATALOG_USER_ID");
		md.setWebLabelName("DEF GRID CATALOG USER ID");
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_HDR_SELECT");
		md.setWebLabelName("DEF HDR SELECT");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_HDR_DELETE");
		md.setWebLabelName("DEF HDR DELETE");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SEARCH_MOD_NAME");
		md.setWebLabelName("DEF SEARCH MOD NAME");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_MAINT_MOD_NAME");
		md.setWebLabelName("DEF MAINT MOD NAME");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SRCH_FROM");
		md.setWebLabelName("DEF SRCH FROM");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_SRCH_TO");
		md.setWebLabelName("DEF SRCH TO");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_TAB_HDR");
		md.setWebLabelName("LBL_TAB_HDR");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_TAB_DTL");
		md.setWebLabelName("LBL_TAB_DTL");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_TAB_FIELDS");
		md.setWebLabelName("LBL_TAB_FIELDS");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		md = new MetaData();
		md.setWebObjectId("LBL_TAB_LIGHTBOX");
		md.setWebLabelName("LBL_TAB_LIGHTBOX");
		md.setColumnSize(35);
		md.setDisplaySize(20);
		md.setTextAreaColSize(20);
		md.setTextAreaRowSize(2);
		md.setIsNullable(1);
		ts.add(md);

		new CatalogSecurityCommonSchema().setMoreSchema(ts);
	}

}